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