UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N2wo9eIrESFX11UFpe/iA8AiLkydAFnqnC+gn+mKpc8='
WHERE
key_id = '1de3fdf5e44c2ff5d2f4ab97d766eb55aeb5eec77ed2b6c4c91994c18b60f3ab'
AND (
token = 'N2wo9eIrESFX11UFpe/iA8AiLkydAFnqnC+gn+mKpc8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)