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