UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QEUBeKYyxoktzMVUqKU17eoX6jiTfojq5y1vDajDDME='
WHERE
key_id = '6b34d6357208a2dd1b36e3f71976553492eea41c7bb715b65c386baa8addf2bf'
AND (
token = 'QEUBeKYyxoktzMVUqKU17eoX6jiTfojq5y1vDajDDME='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)