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