UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vvICS8ZgPtpHGthU/KGclgD6w9TdgQ4DD4100Hi6/GE='
WHERE
key_id = 'cdbaf612dea3e9565cf8b074dd798f5d428c88d2b8941f98df1a3b9183b6bb07'
AND (
token = 'vvICS8ZgPtpHGthU/KGclgD6w9TdgQ4DD4100Hi6/GE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)