UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LopnV6IqEejW7B3ze9W65QNbjIN8B9jV2SujLH5frRk='
WHERE
key_id = 'c5cbcc469ae95334c0228bf64cf58ba492d48d33f132c50658b26f9ed06e229a'
AND (
token = 'LopnV6IqEejW7B3ze9W65QNbjIN8B9jV2SujLH5frRk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)