UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BTiTNoO/RyK8hYN7AYnfDJ/7Dr0Or7Pr8pfWurgCky4='
WHERE
key_id = '1d6c742b2f504964f689e801bf082a4d454e6284fa30246dc08188613005acd5'
AND (
token = 'BTiTNoO/RyK8hYN7AYnfDJ/7Dr0Or7Pr8pfWurgCky4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)