UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'v8HVkt2wZONCKmMi8lhpWpv4ssqO9BKXdwlquoCc6bs='
WHERE
key_id = '27177f1a33c0340d3c8e93046fae5cb438328ae13a67a9e0c234f6bd47cb1b18'
AND (
token = 'v8HVkt2wZONCKmMi8lhpWpv4ssqO9BKXdwlquoCc6bs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)