UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7yHSsShcCJzDInvKW3SNRRjjgL1XCI9bBx8C0SVeyD0='
WHERE
key_id = '20ecb2d8f8c3b5e39c13215e5b0f46943fffd1305b29906e348cd5b6afdf3bf8'
AND (
token = '7yHSsShcCJzDInvKW3SNRRjjgL1XCI9bBx8C0SVeyD0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)