UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FOECG8ZTRUzf5Cp/PAkiUxWkUIZ2sIu9KuiiMChLkl8='
WHERE
key_id = '8d05a6e40adff90ba8842c6959250df35f3858fbf1d6a2b48b39ff5a47904ae3'
AND (
token = 'FOECG8ZTRUzf5Cp/PAkiUxWkUIZ2sIu9KuiiMChLkl8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)