UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DRdqMcbeowwbeZFH9C3lA/T74pGSlEe9garVf9Ec6nI='
WHERE
key_id = '98554d7b92454564f757db5b34e8e219754792f33d305c7232a951c76ef75270'
AND (
token = 'DRdqMcbeowwbeZFH9C3lA/T74pGSlEe9garVf9Ec6nI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)