UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JPNDiwA47jagsEv9KQbE2UeykO12jeIGZ1OhX89B+u0='
WHERE
key_id = 'e13078b6dcee6ec034e3e9b49267462e22c99519524153360bead08375ba0e10'
AND (
token = 'JPNDiwA47jagsEv9KQbE2UeykO12jeIGZ1OhX89B+u0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)