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