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