UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vA7E0YINUS+r7Klt7Hks/BZG8jLnDMu8M1hQu6d4Tpo='
WHERE
key_id = 'd56aedc7fcbb2ec0aebc56ef34d7af8d18fec1b4d3cbb5ba89767341bf69ff4c'
AND (
token = 'vA7E0YINUS+r7Klt7Hks/BZG8jLnDMu8M1hQu6d4Tpo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)