UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BHhr/XyyQkNG8MaqeOS/FQX/bBCULRUKKynCD31v+qU='
WHERE
key_id = '24f2358be24032af63f372fa40099edf6c694ed7e05f8471316cf855e5d81d7f'
AND (
token = 'BHhr/XyyQkNG8MaqeOS/FQX/bBCULRUKKynCD31v+qU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)