UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WjTmFoHxq1l+b9+ddL21ZsnPdgCoWYq92go2oNgViGM='
WHERE
key_id = '8a64ec8335934419f4850f6faffb35c9a4369bc535404fc41d718f9771d49fd5'
AND (
token = 'WjTmFoHxq1l+b9+ddL21ZsnPdgCoWYq92go2oNgViGM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)