UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sBVKHR5b3MpFFdvxuW/+p8oKUgY5p7TGywEawixTrTs='
WHERE
key_id = '0ebb2fef11b2e2dc5b5b002fe912d5cadbc1217645a2e97a5b18eb3b0eeea5ae'
AND (
token = 'sBVKHR5b3MpFFdvxuW/+p8oKUgY5p7TGywEawixTrTs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)