UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZfLfM9xVLkGE9VSMtQRN1vezVeWnlo/7ZTBgEXzswOA='
WHERE
key_id = 'ef2a96e921c80c8c0cc7b1ed42315a5eee6e85371fe49283f23ab22e6a15942b'
AND (
token = 'ZfLfM9xVLkGE9VSMtQRN1vezVeWnlo/7ZTBgEXzswOA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)