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