UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'C9Ge9ogkcv3cNIbUQ30X98iWq8l/xGWDjgrvOxbzCyI=' 
WHERE 
  key_id = '69c8c39bd63dbbf6df75ad81c616e3fafd582e062feb9b45068e31a43f069b9b' 
  AND (
    token = 'C9Ge9ogkcv3cNIbUQ30X98iWq8l/xGWDjgrvOxbzCyI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00038