UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gkIRex653MoTasWhQMNs4bYzSxjtaSoF6G80J6Lf3To='
WHERE
key_id = 'b64c7f144d30186c0f3316a6e29baaa0a690fbabe216556002afb74b63de110b'
AND (
token = 'gkIRex653MoTasWhQMNs4bYzSxjtaSoF6G80J6Lf3To='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)