UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5o+bPDfECKyw+XD+CfWsqQTZ1rESLLd3RRaZ/FHbU8Y='
WHERE
key_id = 'e46063bb5490903e040c17ee939e1a783bf244e9bcc80e61a9ebef54ddc379e7'
AND (
token = '5o+bPDfECKyw+XD+CfWsqQTZ1rESLLd3RRaZ/FHbU8Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)