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