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