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