UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CBtlqjV+s4uxmyDCCJq1TW0+yx7ZdPC6uJaI6q8EMcw='
WHERE
key_id = 'bb1fc3e74167ab6771fe06388ef8082bb38a14abd3de59d809a4c654860ee1ab'
AND (
token = 'CBtlqjV+s4uxmyDCCJq1TW0+yx7ZdPC6uJaI6q8EMcw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)