UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'No5zmh7j2MBmGF0hPZxumKOi9ACOBd+nduwLoDKAsRA='
WHERE
key_id = 'b7ae2c59703c96920b471ee8fb9ba44bfd427fe9b2e7285dcd6201c98b17be3e'
AND (
token = 'No5zmh7j2MBmGF0hPZxumKOi9ACOBd+nduwLoDKAsRA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)