UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'INMp16DcFizGCjGm1IrcSP7qd3dn7ONi37qEIgAt1po='
WHERE
key_id = '642fe0a5bb844e54f7973ba5cf922cb29c0d1578e0b8df26d66cc7e57f11b3e6'
AND (
token = 'INMp16DcFizGCjGm1IrcSP7qd3dn7ONi37qEIgAt1po='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)