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