UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0ZcuiQaPlG2lQCuxB+EG37G/vBCEAOEIAoMd+teoI/U='
WHERE
key_id = '58d8caf7e530d7be1f771c4ac1e650fd8005d1eaef02a98c589059901a9bff27'
AND (
token = '0ZcuiQaPlG2lQCuxB+EG37G/vBCEAOEIAoMd+teoI/U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)